package com.sky.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.github.pagehelper.PageHelper;
import com.sky.constant.MessageConstant;
import com.sky.constant.StatusConstant;
import com.sky.context.BaseContext;
import com.sky.dto.CategoryDTO;
import com.sky.dto.CategoryPageQueryDTO;
import com.sky.entity.Category;
import com.sky.entity.Employee;
import com.sky.exception.DeletionNotAllowedException;
import com.sky.mapper.CategoryMapper;
import com.sky.mapper.DishMapper;
import com.sky.mapper.EmployeeMapper;
import com.sky.mapper.SetmealMapper;
import com.sky.result.PageResult;
import com.sky.service.CategoryService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.time.LocalDateTime;
import java.util.List;

/**
 * 分类业务层
 */
@Service
@Slf4j
public class CategoryServiceImpl  extends ServiceImpl<CategoryMapper, Category>  implements CategoryService {

    @Autowired
    private CategoryMapper categoryMapper;
    @Autowired
    private DishMapper dishMapper;
    @Autowired
    private SetmealMapper setmealMapper;

    /**
     * 新增分类
     * @param categoryDTO
     */
    @Override
    public void save(CategoryDTO categoryDTO) {
        Category category = new Category();
        //属性拷贝
        BeanUtils.copyProperties(categoryDTO, category);

        //分类状态默认为禁用状态0
        category.setStatus(StatusConstant.DISABLE);

//        //设置创建时间、修改时间、创建人、修改人
//        category.setCreateTime(LocalDateTime.now());
//        category.setUpdateTime(LocalDateTime.now());
//        category.setCreateUser(BaseContext.getCurrentId());
//        category.setUpdateUser(BaseContext.getCurrentId());
 //使用了aop公共字段自动填充注解，不需要手动设置

        categoryMapper.insert1(category);


    }



    /**
     * 分页查询
     * @param categoryPageQueryDTO
     * @return
     */
    @Override
    public PageResult page1(CategoryPageQueryDTO categoryPageQueryDTO) {
        //采用mybatis-plus分页插件
        QueryWrapper<Category> queryWrapper = new QueryWrapper<>();
        //分页查询
        Page<Category> page = new Page<>(categoryPageQueryDTO.getPage(), categoryPageQueryDTO.getPageSize());
        Page<Category> pageResult = null;
        //设置查询条件
        if(categoryPageQueryDTO.getName()!= null && !categoryPageQueryDTO.getName().equals("")){
            queryWrapper.like("name", categoryPageQueryDTO.getName());
            queryWrapper.eq("type", categoryPageQueryDTO.getType());
            // 按照 sort 字段升序排序
            queryWrapper.orderByAsc("sort");
            pageResult = categoryMapper.selectPage(page, queryWrapper);
        }else if (categoryPageQueryDTO.getType()!= null){
            queryWrapper.eq("type", categoryPageQueryDTO.getType());
            // 按照 sort 字段升序排序
            queryWrapper.orderByAsc("sort");
            pageResult = categoryMapper.selectPage(page, queryWrapper);
        }else {
            // 按照 sort 字段升序排序
            queryWrapper.orderByAsc("sort");
            pageResult = categoryMapper.selectPage(page, queryWrapper);
        }
        log.info("总记录数: " + pageResult.getTotal());
        return new PageResult(pageResult.getTotal(),pageResult.getRecords());
    }

    /**
     * 根据id删除分类
     * @param id
     */
    public void deleteById(Long id) {
        //查询当前分类是否关联了菜品，如果关联了就抛出业务异常
        Integer count = dishMapper.countByCategoryId(id);
        if(count > 0){
            //当前分类下有菜品，不能删除
            throw new DeletionNotAllowedException(MessageConstant.CATEGORY_BE_RELATED_BY_DISH);
        }

        //查询当前分类是否关联了套餐，如果关联了就抛出业务异常
        count = setmealMapper.countByCategoryId(id);
        if(count > 0){
            //当前分类下有菜品，不能删除
            throw new DeletionNotAllowedException(MessageConstant.CATEGORY_BE_RELATED_BY_SETMEAL);
        }

        //删除分类数据
        categoryMapper.deleteById(id);
    }


    /**
     * 修改分类
     * @param categoryDTO
     */

    @Override
    public void update(CategoryDTO categoryDTO) {
        Category category = categoryMapper.selectById(categoryDTO.getId());

        //属性拷贝
        BeanUtils.copyProperties(categoryDTO, category);
        //设置修改时间、修改人
//        category.setUpdateTime(LocalDateTime.now());
//        category.setUpdateUser(BaseContext.getCurrentId());
        categoryMapper.updateById(category);

    }


    /**
     * 启用、禁用分类
     * @param status
     * @param id
     */
    @Override
    public void startOrStop(Integer status, Long id) {
        Category category = categoryMapper.selectById(id);
        category.setStatus(status);
//        category.setUpdateTime(LocalDateTime.now());
//        category.setUpdateUser(BaseContext.getCurrentId());
        categoryMapper.updateById(category);
    }

    /**
     * 根据类型查询分类
     * @param type
     * @return
     */
    @Override
    public List<Category> list(Integer type) {
        if(type == null){
            return categoryMapper.selectList(null);
        }else {
            QueryWrapper<Category> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("type", type);
            return categoryMapper.selectList(queryWrapper);
        }
    }

}
